﻿CREATE TABLE [dbo].[OrderPaymentInfo] (
    [OrderPaymentID]        UNIQUEIDENTIFIER NOT NULL,
    [PaymentPattern]        TINYINT          NULL,
    [UserID]                BIGINT           NULL,
    [Payment]               MONEY            NULL,
    [OnlinePaymentID]       UNIQUEIDENTIFIER NULL,
    [CompletePaymentStatus] TINYINT          NULL,
    [PapmentNo]             VARCHAR (32)     NULL,
    [TradeNo]               VARCHAR (64)     NULL,
    [TradeTime]             DATETIME         NULL,
    [OfflinePaymentID]      UNIQUEIDENTIFIER NULL,
    CONSTRAINT [PK_ORDERPAYMENTINFO] PRIMARY KEY CLUSTERED ([OrderPaymentID] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'线下支付标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'OfflinePaymentID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'交易时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'TradeTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'流水号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'TradeNo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'支付识别码', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'PapmentNo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'支付完成状态', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'CompletePaymentStatus';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'当前在线支付标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'OnlinePaymentID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'支付金额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'Payment';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'UserID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'支付方式。10：线上支付；20：线下支付；', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'PaymentPattern';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'订单支付信息标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo', @level2type = N'COLUMN', @level2name = N'OrderPaymentID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'订单支付信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'OrderPaymentInfo';

